﻿-- =============================================
-- Script Template
-- =============================================

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


/****Create Default Records ****/
PRINT 'INSERTING DEFAULT DATA .... [Ivy_Sys_TableMaster]'
GO
  --      Ivy_Sys_TableMaster_Insert 1, 'Sys_OrganizationMaster',NULL,1,1,'1',0,-1,NULL,'Default'
		--Go
		--Ivy_Sys_TableMaster_Insert 2, 'Sys_ModuleMaster',NULL,2,1,'1',0,-1,NULL,'Default'
		--Go
		--Ivy_Sys_TableMaster_Insert 3, 'Sys_TableMaster',NULL,3,1,'1',0,-1,NULL,'Default'
		--Go
		--Ivy_Sys_TableMaster_Insert 4, 'Sys_LoginHistoryLog',NULL,4,1,'1',0,-1,NULL,'Default'
		--Go
		--Ivy_Sys_TableMaster_Insert 5, 'Sys_RoleMaster',NULL,5,1,'1',0,-1,NULL,'Default'
		--Go

		--Ivy_Sys_TableMaster_Insert 6, 'User',NULL,6,2,'1',0,-1,NULL,'Default'
		--Go
		--Ivy_Sys_TableMaster_Insert 7, 'UserProfile',NULL,7,2,'1',0,-1,NULL,'Default'
		--Go
		--Ivy_Sys_TableMaster_Insert 8, 'UserRole',NULL,8,2,'1',0,-1,NULL,'Default'
		--Go

		--Ivy_Sys_TableMaster_Insert 9, 'FeedbackUser',NULL,9,3,'1',0,-1,NULL,'Default'
		--Go
		--Ivy_Sys_TableMaster_Insert 10, 'Feedback',NULL,10,3,'1',0,-1,NULL,'Default'
		--Go

		--Ivy_Sys_TableMaster_Insert 11, 'Society',NULL,11,4,'1',0,-1,NULL,'Default'
		--Go
		--Ivy_Sys_TableMaster_Insert 12, 'Flat',NULL,12,4,'1',0,-1,NULL,'Default'
		--Go
		--Ivy_Sys_TableMaster_Insert 13, 'SocietyManagementMemberRegister',NULL,13,4,'1',0,-1,NULL,'Default'
		--Go
		--Ivy_Sys_TableMaster_Insert 14, 'SocietyEmployeeRegister',NULL,14,4,'1',0,-1,NULL,'Default'
		--Go

		--Ivy_Sys_TableMaster_Insert 15, 'FlatOwnerRegister',NULL,11,5,'1',0,-1,NULL,'Default'
		--Go
		--Ivy_Sys_TableMaster_Insert 16, 'FlatResidentRegister',NULL,16,6,'1',0,-1,NULL,'Default'
		--Go
		
INSERT [Sys_TableMaster] ([TableID], [TableName], [TableDescription], [TableSequenceNo], [ModuleID], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, N'Sys_OrganizationMaster', NULL, 1, 1, GETDATE(), GETDATE(), N'1', N'1', 0, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_TableMaster] ([TableID], [TableName], [TableDescription], [TableSequenceNo], [ModuleID], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, N'Sys_ModuleMaster', NULL, 2, 1, GETDATE(), GETDATE(), N'1', N'1', 0, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_TableMaster] ([TableID], [TableName], [TableDescription], [TableSequenceNo], [ModuleID], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (3, N'Sys_TableMaster', NULL, 3, 1, GETDATE(), GETDATE(), N'1', N'1', 0, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_TableMaster] ([TableID], [TableName], [TableDescription], [TableSequenceNo], [ModuleID], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (4, N'Person', NULL, 4, 2, GETDATE(), GETDATE(), N'1', N'1', 0, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_TableMaster] ([TableID], [TableName], [TableDescription], [TableSequenceNo], [ModuleID], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (5, N'PersonProfileImage', NULL, 5, 2, GETDATE(), GETDATE(), N'1', N'1', 0, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_TableMaster] ([TableID], [TableName], [TableDescription], [TableSequenceNo], [ModuleID], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (6, N'User', NULL, 6, 2, GETDATE(), GETDATE(), N'1', N'1', 0, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_TableMaster] ([TableID], [TableName], [TableDescription], [TableSequenceNo], [ModuleID], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (7, N'UserOrganizationRole', NULL, 7, 2, GETDATE(), GETDATE(), N'1', N'1', 0, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_TableMaster] ([TableID], [TableName], [TableDescription], [TableSequenceNo], [ModuleID], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (8, N'Subscription', NULL, 8, 3, GETDATE(), GETDATE(), N'1', N'1', 0, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_TableMaster] ([TableID], [TableName], [TableDescription], [TableSequenceNo], [ModuleID], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (9, N'Feedback', NULL, 9, 3, GETDATE(), GETDATE(), N'1', N'1', 0, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_TableMaster] ([TableID], [TableName], [TableDescription], [TableSequenceNo], [ModuleID], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (10, N'FeedbackUser', NULL, 10, 3, GETDATE(), GETDATE(), N'1', N'1', 0, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_TableMaster] ([TableID], [TableName], [TableDescription], [TableSequenceNo], [ModuleID], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (11, N'Sys_SessionLog', NULL, 11, 4, GETDATE(), GETDATE(), N'1', N'1', 0, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_TableMaster] ([TableID], [TableName], [TableDescription], [TableSequenceNo], [ModuleID], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (12, N'Sys_LoginHistoryLog', NULL, 12, 4, GETDATE(), GETDATE(), N'1', N'1', 0, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_TableMaster] ([TableID], [TableName], [TableDescription], [TableSequenceNo], [ModuleID], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (13, N'Sys_ErrorLog', NULL, 13, 4, GETDATE(), GETDATE(), N'1', N'1', 0, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_TableMaster] ([TableID], [TableName], [TableDescription], [TableSequenceNo], [ModuleID], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (14, N'Sys_ActivityTypeMaster', NULL, 14, 4, GETDATE(), GETDATE(), N'1', N'1', 0, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_TableMaster] ([TableID], [TableName], [TableDescription], [TableSequenceNo], [ModuleID], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (15, N'Sys_ActivityMaster', NULL, 15, 4, GETDATE(), GETDATE(), N'1', N'1', 0, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_TableMaster] ([TableID], [TableName], [TableDescription], [TableSequenceNo], [ModuleID], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (16, N'Sys_RoleMaster', NULL, 16, 4, GETDATE(), GETDATE(), N'1', N'1', 0, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_TableMaster] ([TableID], [TableName], [TableDescription], [TableSequenceNo], [ModuleID], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (17, N'Sys_RoleActivity', NULL, 17, 4, GETDATE(), GETDATE(), N'1', N'1', 0, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [Sys_TableMaster] ([TableID], [TableName], [TableDescription], [TableSequenceNo], [ModuleID], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (18, N'ContentTypeMaster', NULL, 18, 5, GETDATE(), GETDATE(), N'1', N'1', 0, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_TableMaster] ([TableID], [TableName], [TableDescription], [TableSequenceNo], [ModuleID], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (19, N'ContentDataMaster', NULL, 19, 5, GETDATE(), GETDATE(), N'1', N'1', 0, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_TableMaster] ([TableID], [TableName], [TableDescription], [TableSequenceNo], [ModuleID], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (20, N'ContentImageData', NULL, 20, 5, GETDATE(), GETDATE(), N'1', N'1', 0, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_TableMaster] ([TableID], [TableName], [TableDescription], [TableSequenceNo], [ModuleID], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (21, N'ContentBinaryData', NULL, 21, 5, GETDATE(), GETDATE(), N'1', N'1', 0, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_TableMaster] ([TableID], [TableName], [TableDescription], [TableSequenceNo], [ModuleID], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (22, N'ContentRating', NULL, 22, 5, GETDATE(), GETDATE(), N'1', N'1', 0, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_TableMaster] ([TableID], [TableName], [TableDescription], [TableSequenceNo], [ModuleID], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (23, N'ContentFeedback', NULL, 23, 5, GETDATE(), GETDATE(), N'1', N'1', 0, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_TableMaster] ([TableID], [TableName], [TableDescription], [TableSequenceNo], [ModuleID], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (24, N'ContentChoiceOption', NULL, 24, 5, GETDATE(), GETDATE(), N'1', N'1', 0, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_TableMaster] ([TableID], [TableName], [TableDescription], [TableSequenceNo], [ModuleID], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (25, N'ContentChoiceResponse', NULL, 25, 5, GETDATE(), GETDATE(), N'1', N'1', 0, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_TableMaster] ([TableID], [TableName], [TableDescription], [TableSequenceNo], [ModuleID], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (26, N'AlertAndNotificationRegister', NULL, 26, 5, GETDATE(), GETDATE(), N'1', N'1', 0, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_TableMaster] ([TableID], [TableName], [TableDescription], [TableSequenceNo], [ModuleID], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (27, N'AlertAndNotificationRecepientUser', NULL, 27, 5, GETDATE(), GETDATE(), N'1', N'1', 0, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_TableMaster] ([TableID], [TableName], [TableDescription], [TableSequenceNo], [ModuleID], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (28, N'TaskRegister', NULL, 28, 5, GETDATE(), GETDATE(), N'1', N'1', 0, 0, -1, NULL, (SELECT @@SERVERNAME))
